﻿<html lang="zh">
<head>
    <title>数据库设计文档</title>
    <style type='text/css'>
        body {
            padding-bottom: 50px
        }

        body,
        td {
            font-family: verdana, fantasy;
            font-size: 12px;
            line-height: 150%
        }

        table {
            width: 100%;
            background-color: #ccc;
            margin: 5px 0
        }

        td {
            background-color: #fff;
            padding: 3px 3px 3px 10px
        }

        thead td {
            text-align: center;
            font-weight: bold;
            background-color: #eee
        }

        a:link,
        a:visited,
        a:active {
            color: #015fb6;
            text-decoration: none
        }

        a:hover {
            color: #e33e06
        }
    </style>
</head>
<body style='text-align:center;'>
<div style='width:800px; margin:20px auto; text-align:left;'><a name='index'></a>
    <h2 style='text-align:center; line-height:50px;'>数据库设计文档</h2>
    <div><b>数据库名：mengchongdb</b><br><b>文档版本：1.0.0</b><br><b>文档描述：数据库设计文档生成</b><br></div>
    <table cellspacing='1'>
        <thead>
        <tr>
            <td style='width:40px; '>序号</td>
            <td>表名</td>
            <td>说明</td>
        </tr>
        </thead>
        <tr>
            <td style='text-align:center;'>1</td>
            <td><a href='#orderid'>orderid</a></td>
            <td>订单ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>2</td>
            <td><a href='#order_cart'>order_cart</a></td>
            <td>订单购物车</td>
        </tr>
        <tr>
            <td style='text-align:center;'>3</td>
            <td><a href='#order_logistics'>order_logistics</a></td>
            <td>订单物流编号</td>
        </tr>
        <tr>
            <td style='text-align:center;'>4</td>
            <td><a href='#order_pay'>order_pay</a></td>
            <td>订单支付</td>
        </tr>
        <tr>
            <td style='text-align:center;'>5</td>
            <td><a href='#order_table'>order_table</a></td>
            <td>订单表</td>
        </tr>
        <tr>
            <td style='text-align:center;'>6</td>
            <td><a href='#product'>product</a></td>
            <td>产品</td>
        </tr>
        <tr>
            <td style='text-align:center;'>7</td>
            <td><a href='#product_banner'>product_banner</a></td>
            <td>产品标语</td>
        </tr>
        <tr>
            <td style='text-align:center;'>8</td>
            <td><a href='#product_img'>product_img</a></td>
            <td>产品图片</td>
        </tr>
        <tr>
            <td style='text-align:center;'>9</td>
            <td><a href='#product_keyword'>product_keyword</a></td>
            <td>产品关键字</td>
        </tr>
        <tr>
            <td style='text-align:center;'>10</td>
            <td><a href='#product_type'>product_type</a></td>
            <td>产品类型</td>
        </tr>
        <tr>
            <td style='text-align:center;'>11</td>
            <td><a href='#store'>store</a></td>
            <td>商店</td>
        </tr>
        <tr>
            <td style='text-align:center;'>12</td>
            <td><a href='#user'>user</a></td>
            <td>用户</td>
        </tr>
        <tr>
            <td style='text-align:center;'>13</td>
            <td><a href='#user_logs'>user_logs</a></td>
            <td>用户日志</td>
        </tr>
        <tr>
            <td style='text-align:center;'>14</td>
            <td><a href='#user_site'>user_site</a></td>
            <td>用户端</td>
        </tr>
    </table><a name='orderid'></a>
    <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：orderid</b></div>
    <div>说明：</div>
    <div>数据列：</div>
    <table cellspacing='1'>
        <thead>
        <tr>
            <td style='width:40px; '>序号</td>
            <td>名称</td>
            <td>数据类型</td>
            <td>长度</td>
            <td>小数位</td>
            <td>允许空值</td>
            <td>主键</td>
            <td>默认值</td>
            <td>说明</td>
        </tr>
        </thead>
        <tr>
            <td style='text-align:center;'>1</td>
            <td>order_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>N</td>
            <td align='center'>Y</td>
            <td align='center'></td>
            <td align='center'>订单ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>2</td>
            <td>user_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>用户ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>3</td>
            <td>site_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>地点编码</td>
        </tr>
        <tr>
            <td style='text-align:center;'>4</td>
            <td>type</td>
            <td align='center'>tinyint</td>
            <td align='center'>4</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>类型</td>
        </tr>
        <tr>
            <td style='text-align:center;'>5</td>
            <td>created_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>建立时间</td>
        </tr>
    </table><a name='order_cart'></a>
    <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：order_cart</b></div>
    <div>说明：</div>
    <div>数据列：</div>
    <table cellspacing='1'>
        <thead>
        <tr>
            <td style='width:40px; '>序号</td>
            <td>名称</td>
            <td>数据类型</td>
            <td>长度</td>
            <td>小数位</td>
            <td>允许空值</td>
            <td>主键</td>
            <td>默认值</td>
            <td>说明</td>
        </tr>
        </thead>
        <tr>
            <td style='text-align:center;'>1</td>
            <td>order_cart_id</td>
            <td align='center'>bigint</td>
            <td align='center'>20</td>
            <td align='center'>0</td>
            <td align='center'>N</td>
            <td align='center'>Y</td>
            <td align='center'></td>
            <td align='center'>订单购物车ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>2</td>
            <td>product_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>产品ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>3</td>
            <td>product_counts</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>产品数量</td>
        </tr>
        <tr>
            <td style='text-align:center;'>4</td>
            <td>product_size_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>产品尺寸编号</td>
        </tr>
        <tr>
            <td style='text-align:center;'>5</td>
            <td>user_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>用户ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>6</td>
            <td>created_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>建立时间</td>
        </tr>
        <tr>
            <td style='text-align:center;'>7</td>
            <td>updated_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>更新时间</td>
        </tr>
        <tr>
            <td style='text-align:center;'>8</td>
            <td>flag</td>
            <td align='center'>tinyint</td>
            <td align='center'>4</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>标识</td>
        </tr>
    </table><a name='order_logistics'></a>
    <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：order_logistics</b></div>
    <div>说明：</div>
    <div>数据列：</div>
    <table cellspacing='1'>
        <thead>
        <tr>
            <td style='width:40px; '>序号</td>
            <td>名称</td>
            <td>数据类型</td>
            <td>长度</td>
            <td>小数位</td>
            <td>允许空值</td>
            <td>主键</td>
            <td>默认值</td>
            <td>说明</td>
        </tr>
        </thead>
        <tr>
            <td style='text-align:center;'>1</td>
            <td>logistics_code</td>
            <td align='center'>varchar</td>
            <td align='center'>50</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>物流编号</td>
        </tr>
        <tr>
            <td style='text-align:center;'>2</td>
            <td>company</td>
            <td align='center'>varchar</td>
            <td align='center'>50</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>公司</td>
        </tr>
        <tr>
            <td style='text-align:center;'>3</td>
            <td>order_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>订单ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>4</td>
            <td>updatedTime</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>更新时间</td>
        </tr>
        <tr>
            <td style='text-align:center;'>5</td>
            <td>is_receive</td>
            <td align='center'>tinyint</td>
            <td align='center'>4</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>接收状态</td>
        </tr>
    </table><a name='order_pay'></a>
    <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：order_pay</b></div>
    <div>说明：</div>
    <div>数据列：</div>
    <table cellspacing='1'>
        <thead>
        <tr>
            <td style='width:40px; '>序号</td>
            <td>名称</td>
            <td>数据类型</td>
            <td>长度</td>
            <td>小数位</td>
            <td>允许空值</td>
            <td>主键</td>
            <td>默认值</td>
            <td>说明</td>
        </tr>
        </thead>
        <tr>
            <td style='text-align:center;'>1</td>
            <td>pay_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>N</td>
            <td align='center'>Y</td>
            <td align='center'></td>
            <td align='center'>付款编号</td>
        </tr>
        <tr>
            <td style='text-align:center;'>2</td>
            <td>order_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>订单ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>3</td>
            <td>pay_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>支付时间</td>
        </tr>
        <tr>
            <td style='text-align:center;'>4</td>
            <td>is_refund</td>
            <td align='center'>tinyint</td>
            <td align='center'>4</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>退款状态</td>
        </tr>
        <tr>
            <td style='text-align:center;'>5</td>
            <td>refund_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>退款时间</td>
        </tr>
        <tr>
            <td style='text-align:center;'>6</td>
            <td>refund_code</td>
            <td align='center'>varchar</td>
            <td align='center'>50</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>退款编号</td>
        </tr>
    </table><a name='order_table'></a>
    <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：order_table</b></div>
    <div>说明：</div>
    <div>数据列：</div>
    <table cellspacing='1'>
        <thead>
        <tr>
            <td style='width:40px; '>序号</td>
            <td>名称</td>
            <td>数据类型</td>
            <td>长度</td>
            <td>小数位</td>
            <td>允许空值</td>
            <td>主键</td>
            <td>默认值</td>
            <td>说明</td>
        </tr>
        </thead>
        <tr>
            <td style='text-align:center;'>1</td>
            <td>order_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>N</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>订单ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>2</td>
            <td>product_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>产品ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>3</td>
            <td>order_cart_id</td>
            <td align='center'>bigint</td>
            <td align='center'>20</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>购物车ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>4</td>
            <td>total_price</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>总价</td>
        </tr>
        <tr>
            <td style='text-align:center;'>5</td>
            <td>site_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>地点编码</td>
        </tr>
        <tr>
            <td style='text-align:center;'>6</td>
            <td>product_size_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>产品尺寸编号</td>
        </tr>
        <tr>
            <td style='text-align:center;'>7</td>
            <td>type</td>
            <td align='center'>tinyint</td>
            <td align='center'>4</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>类型</td>
        </tr>
        <tr>
            <td style='text-align:center;'>8</td>
            <td>created_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>建立时间</td>
        </tr>
    </table><a name='product'></a>
    <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：product</b></div>
    <div>说明：</div>
    <div>数据列：</div>
    <table cellspacing='1'>
        <thead>
        <tr>
            <td style='width:40px; '>序号</td>
            <td>名称</td>
            <td>数据类型</td>
            <td>长度</td>
            <td>小数位</td>
            <td>允许空值</td>
            <td>主键</td>
            <td>默认值</td>
            <td>说明</td>
        </tr>
        </thead>
        <tr>
            <td style='text-align:center;'>1</td>
            <td>product_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>N</td>
            <td align='center'>Y</td>
            <td align='center'></td>
            <td align='center'>产品ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>2</td>
            <td>title</td>
            <td align='center'>varchar</td>
            <td align='center'>255</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>标题</td>
        </tr>
        <tr>
            <td style='text-align:center;'>3</td>
            <td>price</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>价格</td>
        </tr>
        <tr>
            <td style='text-align:center;'>4</td>
            <td>product_type_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>产品类型ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>5</td>
            <td>stock</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>库存</td>
        </tr>
        <tr>
            <td style='text-align:center;'>6</td>
            <td>is_sale</td>
            <td align='center'>tinyint</td>
            <td align='center'>4</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>销售状态</td>
        </tr>
        <tr>
            <td style='text-align:center;'>7</td>
            <td>created_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>建立时间</td>
        </tr>
        <tr>
            <td style='text-align:center;'>8</td>
            <td>store_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>商店ID</td>
        </tr>
    </table><a name='product_banner'></a>
    <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：product_banner</b></div>
    <div>说明：</div>
    <div>数据列：</div>
    <table cellspacing='1'>
        <thead>
        <tr>
            <td style='width:40px; '>序号</td>
            <td>名称</td>
            <td>数据类型</td>
            <td>长度</td>
            <td>小数位</td>
            <td>允许空值</td>
            <td>主键</td>
            <td>默认值</td>
            <td>说明</td>
        </tr>
        </thead>
        <tr>
            <td style='text-align:center;'>1</td>
            <td>banner_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>N</td>
            <td align='center'>Y</td>
            <td align='center'></td>
            <td align='center'>广告ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>2</td>
            <td>product_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>产品ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>3</td>
            <td>start_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>开启时间</td>
        </tr>
        <tr>
            <td style='text-align:center;'>4</td>
            <td>end_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>结束时间</td>
        </tr>
        <tr>
            <td style='text-align:center;'>5</td>
            <td>flag</td>
            <td align='center'>tinyint</td>
            <td align='center'>4</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>标识</td>
        </tr>
        <tr>
            <td style='text-align:center;'>6</td>
            <td>created_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>建立时间</td>
        </tr>
    </table><a name='product_img'></a>
    <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：product_img</b></div>
    <div>说明：</div>
    <div>数据列：</div>
    <table cellspacing='1'>
        <thead>
        <tr>
            <td style='width:40px; '>序号</td>
            <td>名称</td>
            <td>数据类型</td>
            <td>长度</td>
            <td>小数位</td>
            <td>允许空值</td>
            <td>主键</td>
            <td>默认值</td>
            <td>说明</td>
        </tr>
        </thead>
        <tr>
            <td style='text-align:center;'>1</td>
            <td>img_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>N</td>
            <td align='center'>Y</td>
            <td align='center'></td>
            <td align='center'>图片ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>2</td>
            <td>img_url</td>
            <td align='center'>varchar</td>
            <td align='center'>50</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>图片地址</td>
        </tr>
        <tr>
            <td style='text-align:center;'>3</td>
            <td>product_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>产品ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>4</td>
            <td>img_type</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>图片类型</td>
        </tr>
        <tr>
            <td style='text-align:center;'>5</td>
            <td>img_order</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>图片顺序</td>
        </tr>
        <tr>
            <td style='text-align:center;'>6</td>
            <td>created_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>建立时间</td>
        </tr>
    </table><a name='product_keyword'></a>
    <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：product_keyword</b></div>
    <div>说明：</div>
    <div>数据列：</div>
    <table cellspacing='1'>
        <thead>
        <tr>
            <td style='width:40px; '>序号</td>
            <td>名称</td>
            <td>数据类型</td>
            <td>长度</td>
            <td>小数位</td>
            <td>允许空值</td>
            <td>主键</td>
            <td>默认值</td>
            <td>说明</td>
        </tr>
        </thead>
        <tr>
            <td style='text-align:center;'>1</td>
            <td>keyword</td>
            <td align='center'>varchar</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>关键词</td>
        </tr>
        <tr>
            <td style='text-align:center;'>2</td>
            <td>product_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>产品ID</td>
        </tr>
    </table><a name='product_type'></a>
    <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：product_type</b></div>
    <div>说明：</div>
    <div>数据列：</div>
    <table cellspacing='1'>
        <thead>
        <tr>
            <td style='width:40px; '>序号</td>
            <td>名称</td>
            <td>数据类型</td>
            <td>长度</td>
            <td>小数位</td>
            <td>允许空值</td>
            <td>主键</td>
            <td>默认值</td>
            <td>说明</td>
        </tr>
        </thead>
        <tr>
            <td style='text-align:center;'>1</td>
            <td>product_type_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>N</td>
            <td align='center'>Y</td>
            <td align='center'></td>
            <td align='center'>产品类型ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>2</td>
            <td>name</td>
            <td align='center'>varchar</td>
            <td align='center'>100</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>名称</td>
        </tr>
        <tr>
            <td style='text-align:center;'>3</td>
            <td>parent_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>产品ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>4</td>
            <td>remark</td>
            <td align='center'>text</td>
            <td align='center'>65535</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>描述</td>
        </tr>
        <tr>
            <td style='text-align:center;'>5</td>
            <td>created_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>建立时间</td>
        </tr>
    </table><a name='store'></a>
    <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：store</b></div>
    <div>说明：</div>
    <div>数据列：</div>
    <table cellspacing='1'>
        <thead>
        <tr>
            <td style='width:40px; '>序号</td>
            <td>名称</td>
            <td>数据类型</td>
            <td>长度</td>
            <td>小数位</td>
            <td>允许空值</td>
            <td>主键</td>
            <td>默认值</td>
            <td>说明</td>
        </tr>
        </thead>
        <tr>
            <td style='text-align:center;'>1</td>
            <td>store_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>N</td>
            <td align='center'>Y</td>
            <td align='center'></td>
            <td align='center'>商店ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>2</td>
            <td>store_name</td>
            <td align='center'>varchar</td>
            <td align='center'>50</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>商店名称</td>
        </tr>
        <tr>
            <td style='text-align:center;'>3</td>
            <td>user_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>用户ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>4</td>
            <td>created_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>建立时间</td>
        </tr>
        <tr>
            <td style='text-align:center;'>5</td>
            <td>store_flag</td>
            <td align='center'>tinyint</td>
            <td align='center'>4</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>商店标识</td>
        </tr>
    </table><a name='user'></a>
    <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：user</b></div>
    <div>说明：</div>
    <div>数据列：</div>
    <table cellspacing='1'>
        <thead>
        <tr>
            <td style='width:40px; '>序号</td>
            <td>名称</td>
            <td>数据类型</td>
            <td>长度</td>
            <td>小数位</td>
            <td>允许空值</td>
            <td>主键</td>
            <td>默认值</td>
            <td>说明</td>
        </tr>
        </thead>
        <tr>
            <td style='text-align:center;'>1</td>
            <td>user_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>N</td>
            <td align='center'>Y</td>
            <td align='center'></td>
            <td align='center'>用户ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>2</td>
            <td>user_name</td>
            <td align='center'>varchar</td>
            <td align='center'>50</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>用户名称</td>
        </tr>
        <tr>
            <td style='text-align:center;'>3</td>
            <td>user_phone</td>
            <td align='center'>varchar</td>
            <td align='center'>11</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>用户号码</td>
        </tr>
        <tr>
            <td style='text-align:center;'>4</td>
            <td>user_password</td>
            <td align='center'>varchar</td>
            <td align='center'>255</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>用户密码</td>
        </tr>
        <tr>
            <td style='text-align:center;'>5</td>
            <td>salt</td>
            <td align='center'>varchar</td>
            <td align='center'>255</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>盐值</td>
        </tr>
        <tr>
            <td style='text-align:center;'>6</td>
            <td>created_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>建立时间</td>
        </tr>
    </table><a name='user_logs'></a>
    <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：user_logs</b></div>
    <div>说明：</div>
    <div>数据列：</div>
    <table cellspacing='1'>
        <thead>
        <tr>
            <td style='width:40px; '>序号</td>
            <td>名称</td>
            <td>数据类型</td>
            <td>长度</td>
            <td>小数位</td>
            <td>允许空值</td>
            <td>主键</td>
            <td>默认值</td>
            <td>说明</td>
        </tr>
        </thead>
        <tr>
            <td style='text-align:center;'>1</td>
            <td>log_id</td>
            <td align='center'>bigint</td>
            <td align='center'>20</td>
            <td align='center'>0</td>
            <td align='center'>N</td>
            <td align='center'>Y</td>
            <td align='center'></td>
            <td align='center'>日志ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>2</td>
            <td>user_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>用户ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>3</td>
            <td>log_type</td>
            <td align='center'>tinytext</td>
            <td align='center'>255</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>日志类型</td>
        </tr>
        <tr>
            <td style='text-align:center;'>4</td>
            <td>view_url</td>
            <td align='center'>varchar</td>
            <td align='center'>50</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>查看地址</td>
        </tr>
        <tr>
            <td style='text-align:center;'>5</td>
            <td>user_ip</td>
            <td align='center'>varchar</td>
            <td align='center'>50</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>用户IP地址</td>
        </tr>
        <tr>
            <td style='text-align:center;'>6</td>
            <td>created_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>建立时间</td>
        </tr>
    </table><a name='user_site'></a>
    <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：user_site</b></div>
    <div>说明：</div>
    <div>数据列：</div>
    <table cellspacing='1'>
        <thead>
        <tr>
            <td style='width:40px; '>序号</td>
            <td>名称</td>
            <td>数据类型</td>
            <td>长度</td>
            <td>小数位</td>
            <td>允许空值</td>
            <td>主键</td>
            <td>默认值</td>
            <td>说明</td>
        </tr>
        </thead>
        <tr>
            <td style='text-align:center;'>1</td>
            <td>site_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>N</td>
            <td align='center'>Y</td>
            <td align='center'></td>
            <td align='center'>地点编码</td>
        </tr>
        <tr>
            <td style='text-align:center;'>2</td>
            <td>user_id</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>用户ID</td>
        </tr>
        <tr>
            <td style='text-align:center;'>3</td>
            <td>country</td>
            <td align='center'>varchar</td>
            <td align='center'>20</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>国家</td>
        </tr>
        <tr>
            <td style='text-align:center;'>4</td>
            <td>province</td>
            <td align='center'>varchar</td>
            <td align='center'>20</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>省份</td>
        </tr>
        <tr>
            <td style='text-align:center;'>5</td>
            <td>city</td>
            <td align='center'>varchar</td>
            <td align='center'>20</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>城市</td>
        </tr>
        <tr>
            <td style='text-align:center;'>6</td>
            <td>detail_site</td>
            <td align='center'>varchar</td>
            <td align='center'>20</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>地点详细信息</td>
        </tr>
        <tr>
            <td style='text-align:center;'>7</td>
            <td>receiver_phone</td>
            <td align='center'>varchar</td>
            <td align='center'>11</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>接收人号码</td>
        </tr>
        <tr>
            <td style='text-align:center;'>8</td>
            <td>receiver_name</td>
            <td align='center'>varchar</td>
            <td align='center'>11</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>接收人名称</td>
        </tr>
        <tr>
            <td style='text-align:center;'>9</td>
            <td>site_type</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>地点类型</td>
        </tr>
        <tr>
            <td style='text-align:center;'>10</td>
            <td>created_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>建立时间</td>
        </tr>
    </table>
</div>
<footer></footer>
</body>
</html>
